Database configuration files
When you first run Results against a database, the following message appears:
In this message, sports is the name of the database you are using to start Results. If you are starting Results with more than one database, only the name of the first database connected will appear in this dialog box.
Initial build and the query configuration files
The initial build creates a file called dbname.qc7, where dbname is the unique name of the you are using to start Results. This file is called the query configuration file (QC7 file), and it contains the Results default settings for table relationships, security settings, label formats, export formats, and page formats. All the users who use Results with the specified database access this file. Results cannot run without the QC7 file. Therefore, if you are running Results for the first time against a new database or group of databases, Results must perform the initial build to create this file.
The QC7 file is named for the first database connected; therefore, the order in which you connect databases when you start Results is important. For example, if you perform an initial build on the databases db1 and db2 (in that order), the QC7 file for these databases together is called db1.qc7. If you start Results with db2 and db1 (in that order), Progress returns a message that the db2.qc7 file was not found. If you start Results with only the db1 database, a message states that the database configuration has changed and requests you to rebuild the query configuration file.
QC7 file. However, the menu option Query
Site Admin Application Rebuild causes Results to rewrite the entire QC7 file. When Results rewrites a QC7 file, it uses information from all connected databases.
Location of the QC7 file
Results attempts to create the QC7 file in the same directory that contains the database (dbname.db). However, if the database is on another machine, and Results cannot locate that directory, Results places the QC7 file in the current working directory. Once Results creates a QC7 file, you can move it anywhere in your PROPATH.
When you start Results, it looks for the QC7 file in the current working directory. If it cannot find it there, it looks in the PROPATH. For more information about PROPATH, see OpenEdge Getting Started: Installation and Configuration
.
Query configuration log file
During the initial build and subsequent rewrites of a query configuration file, Results logs information in a query configuration log file (QL file). The name of the query configuration log file is dbname.ql, where dbname is the name of the first database connected for the session. The information in the query configuration log file can consist of compiler error messages and compilation times. Results creates the QL file in the same directory as the QC7 file.
Results continues to write to the QL file associated with a QC7 file for the life of the QC7 file. If the QL file becomes too large, simply delete the file. Results automatically creates a new QL file.
Results.l file and initial builds
Default information for a Results site is stored in the results.l file located in the aderes directory in the OpenEdge product directory ($DLC\GUI). The results.l file is an ASCII file that contains the following default settings:
Results incorporates the contents of the results.l file into a QC7 file during initial build of the QC7 file. Subsequent rewrites of the QC7 file do not access the results.l file.
You can configure your default site settings by editing the contents of the results.l file prior to performing an initial build. Create a backup copy of the results.l file prior to editing it.
results.l file, you might encounter problems during the initial build of a QC7 file.
See Appendix C, "Results Files," for information about the contents of the results.l file.
After the initial build
After the initial build, you can use the menu options Query Site Admin and Query Customize to override the default environment settings and customize Results for your own site. Most of these menu options edit the content of the current QC7 file.
The remainder of this chapter describes how you can customize Results for your site using the Site Admin menu. See Chapter 3, "Programming Results," for information about how you can extend and configure Results using the Customize menu.